Sameer Karkhanis
Sameer Karkhanis
Reactions
-
Re: Formula Help - SOS
Try this, hopefully that works: =COUNTIFS([Owner]:[Owner], AND(@cell <> "ABC Inc", @cell <> "GreyBird"), [Date]:[Date], DATE(2022, 2, 1) )1 · -
Re: Nested formula with sheet references help
Try this, =MAX(COLLECT({Training Data Range 2 - Date}, {Training Data Range 1 - Name}, Name@row))1 · -
Re: How to Convert Dropdown text into number of days
There is no label value concept in the dropdown so you cannot do that in the same column (Reference), however if you want to populate the next submission date column then you can use the IF formula a…1 · -
Re: COUNTIFS formula with date fields is giving me trouble
Syntactically I see incorrect bracket used after MedschedulerCreated range, should be } instead of ). There is also no need of = sign in the first criteria when comparing the text value as it is assu…1 · -
Re: Can I ignore a row that is missing data and is corrupting my formulas?
@ECD Auto Design Couple of options: In your formula you can do a check if the cell has value using ISBLANK() function and manage your formula logic. You can just wrap the formula within IFERROR(<y…1 ·
